<?php
global $cndb;

$cndb->query("CREATE TABLE IF NOT EXISTS `firstdata_records` (`fdr_id` bigint(20) not null auto_increment, `fdr_date` timestamp default current_timestamp, `fdr_name` varchar(100), `fdr_card` varchar(16), `fdr_type` bigint(20), primary key (`fdr_id`), key (`fdr_type`))");

$cndb->query("CREATE TABLE IF NOT EXISTS `firstdata_products` (`fdp_id` bigint(20) not null auto_increment, `fdp_name` varchar(50), `fdp_description` varchar(500), `fdp_price` decimal (10,2), primary key (`fdp_id`))");

$insert = array('lf_display_name'=>'Credit Card Information', 'lf_data_type'=>'Firstdata Credit Card', 'lf_column'=>'l2_credit_card', 'lf_ltype'=>'2');
$cndb->insert('cn_listing_fields', $insert);

?>